package com.opal.salescost.mapper;

import com.opal.salescost.entity.SalesorgForm;
import com.opal.salescost.entity.table.VCxSalescostZp;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.mapping.StatementType;
import org.springframework.stereotype.Component;

import java.util.List;

@Component
public interface VCxSalescostZpMapper {

    List<VCxSalescostZp> findAll(SalesorgForm salesorgForm);

    List<VCxSalescostZp>getPage(SalesorgForm salesorgForm);

    int getCount(SalesorgForm salesorgForm);

    @Select({"call get_salescost.gp_cx_saleccost(#{pkSalesorg,mode=IN,jdbcType=VARCHAR}, #{Time,mode=IN,jdbcType=VARCHAR})"})
    @Options(statementType= StatementType.CALLABLE)
    void CallGpCxSaleccost(@Param("pkSalesorg") String pkSalesorg, @Param("Time") String Time);
}